﻿<%@ Page Language="C#" AutoEventWireup="true" Inherits="Products_ProductDetail_description" Codebehind="description.aspx.cs" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <p style="margin-left: 320px">
            <asp:Label ID="lError" runat="server" Font-Bold="True" ForeColor="Red"></asp:Label>
            <br />
        </p>
        <asp:Table ID="tableProduct" runat ="server" Width="100%" BorderWidth="1px" 
            GridLines="Both">
            <asp:TableHeaderRow>
                <asp:TableHeaderCell ColumnSpan="2" Font-Bold="true" HorizontalAlign="Center" VerticalAlign="Middle" runat="server" CssClass="title_table" Text="Mô tả chi tiết sản phẩm">
                </asp:TableHeaderCell>
            </asp:TableHeaderRow>
            
            <asp:TableRow>
                <asp:TableCell Text="Nhà sản xuất: " runat="server" BackColor="Silver" Width="150">
                </asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lNhaSanXuat">                
                </asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell Text="Quốc gia: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lQuocGia"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell Text="Nhà phân phối: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lNhaPhanPhoi"></asp:TableCell>
            </asp:TableRow>
                                    
            <asp:TableRow>
                <asp:TableCell Text="Ngày thêm sản phẩm: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lNgayThemSP"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell Text="Mô tả sản phẩm: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lMoTa"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell ID="TableCell1" Text="Số lượng tồn: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lSoLuongTon"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell ID="TableCell2" Text="Bảo hành: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lBaoHanh"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell ID="TableCell3" Text="Loại linh kiện: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lLoaiLinhKien"></asp:TableCell>
            </asp:TableRow>           
                                    
            <asp:TableRow>
                <asp:TableCell ID="TableCell6" Text="Hình thức khuyến mãi: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lKhuyenMai"></asp:TableCell>
            </asp:TableRow>
            
            <asp:TableRow>
                <asp:TableCell ID="TableCell7" Text="Phần trăm giảm: " runat="server" BackColor="Silver" Width="150"></asp:TableCell>
                <asp:TableCell Text="" runat="server" ID="lPhanTramGiam"></asp:TableCell>
            </asp:TableRow>            
                                    
        </asp:Table>
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            SelectCommand="SELECT SAN_PHAM.MoTa, SAN_PHAM.SoLuongTon, SAN_PHAM.NgayThemSP, SAN_PHAM.BaoHanh, SAN_PHAM.LoaiLinhKien, NHA_PHAN_PHOI.TenNhaPhanPhoi, NHA_SAN_XUAT.TenNSX, NHA_SAN_XUAT.QuocGia, KHUYEN_MAI.HinhThuc, KHUYEN_MAI.PhanTramGiam FROM NHA_SAN_XUAT RIGHT JOIN SAN_PHAM ON NHA_SAN_XUAT.id = SAN_PHAM.idNSX LEFT JOIN KHUYEN_MAI ON SAN_PHAM.idKhuyenMai = KHUYEN_MAI.id LEFT JOIN NHA_PHAN_PHOI ON SAN_PHAM.idNhaPhanPhoi = NHA_PHAN_PHOI.id ">
        </asp:SqlDataSource>
        
    </div>
    </form>
</body>
</html>
